/*******************************************************************************
 * This file is part of blueprint4j www.blueprint4j.org.
 * 
 *     blueprint4j is free software: you can redistribute it and/or modify
 *     it under the terms of the GNU Lesser General Public License as published by
 *     the Free Software Foundation, either version 3 of the License, or
 *     (at your option) any later version.
 * 
 *     blueprint4j is distributed in the hope that it will be useful,
 *     but WITHOUT ANY WARRANTY; without even the implied warranty of
 *     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *     GNU Lesser General Public License for more details.
 * 
 *     You should have received a copy of the GNU Lesser General Public License
 *     along with blueprint4j. If not, see <http://www.gnu.org/licenses/>.
 ******************************************************************************/
package blueprint4j.db;

import java.util.Date;
import java.sql.ResultSet;
import java.sql.SQLException;

import blueprint4j.utils.*;

import java.text.SimpleDateFormat;

public class FieldDate extends Field implements BindDateInterface {
	private static final long serialVersionUID = 1L;

	public static SimpleDateFormat date_format = new SimpleDateFormat("yyyy-MM-dd");
	/**
	 * protected FieldDate( String p_name, String p_description, boolean p_key_field)
	 *
	 * Name: Name of field -> equivalent to table.field_name
	 * Description: Description of field
	 * key_field: Is this field a key field in the table (index field)
	 */
	public FieldDate( String p_name, int p_field_type , String p_description, Entity entity ) {
		super( p_name,p_field_type, p_description, entity );
	}

	public Field newInstance(Entity entity) {
		return new FieldDate(getName(),getFieldType(),getDescription(),entity);
	}

	protected void setFieldValue( ResultSet result_set )
	throws DataException {
		try {
			java.sql.Date date = result_set.getDate( getName() );
			if (date !=null) {
				setObject( new Date(date.getTime() ));
			} else {
				setObject( null );
			}
		} catch ( SQLException se ) {
			Log.debug.out(se);
			throw new DataException( "Can not retrieve '" + getName() + "'",se);
		}
	}

	public Date get() {
		return (Date) getObject();
	}

	public void set(Date value) {
		setObject(value);
	}

	public String toString() {
		if (getObject() != null) {
			return getObject().toString();
		} else {
			return null;
		}
	}

	/**
	 * Return data in a suitable SQL format
	 */
	public String getSQLValue()
	throws DataException {
		if (getObject() == null) {
			return "null";
		}
		return entity.getConnection().getDataBaseUtils().convertDateToSQLString(get());
	}

	/**
	 * An overloaded equals method that only accepts the correct type
	 */
	public boolean equals(Date value) {
		return get().equals(value);
	}

	public Object getPreparedStatementObject()
	throws DataException {
		if (getObject() == null) return null;
		return new java.sql.Timestamp(get().getTime());
	}

	public String getSerializable() {
		if (getObject() == null) {
			return "null";
		}
		return date_format.format(get());
	}

	public void setSerializable(String p_value) throws BindException{
		if ("null".equalsIgnoreCase(p_value)) {
			setObject(null);
		} else {
			try {
				setObject(date_format.parse(p_value));
			} catch(Exception e) {
				Log.debug.out(e);
			}
		}
	}

}
